# Filtering Table

The FilteringTable widget is the second Dojo widget that can take a plain table of data and add functionality to it. Like SortableTable, you can sort columns by clicking on the column heading. Unlike SortableTable, FilteringTable can also:

- Multiple column sorting (no limit, default is 1)
- Sort in place: no destruction of markup takes place to sort
- Allow you to set up "filterers", which will show/hide records based on criteria

However, the biggest changes are under the hood: a brand new data store model is underlying the FilteringTable (a preview of what is coming with dojo.data). This data store (accessible programmatically as [widget].store) allows you to pass it an array of JSON objects that may or may not be complex in nature.

What does that mean? It means that you can pass the store nested objects and show them within the FilteringTable as a field. Take a look at the source of this page to see a demonstration.

## Filtering Table, parsed from existing HTML data

### Data manipulation

Change the value of Adam's Label (html allowed):

### Filtering

Name | Date Added | Date Modified | Label
--- | --- | --- | ---
Adam | 3/1/2004 | 11/1/2003 | Lorem ipsum dolor sit amet... consectetuer
Betty | 6/15/2005 | 1/7/2006 | Adipiscing elit, sed diam nonummy nibh euismod
Carla | 4/23/2002 | 3/1/2004 | tincidunt ut laoreet dolore magna aliquam erat volutpat.
David | 11/1/2003 | 6/15/2005 | Ut wisi enim ad minim veniam, quis
Esther | 1/7/2006 | 4/23/2002 | nostrud exerci tation ullamcorper
Fred | 3/1/2004 | 11/1/2003 | suscipit lobortis nisl ut aliquip ex ea commodo consequat.
Greg | 6/15/2005 | 1/7/2006 | Lorem ipsum dolor sit amet... consectetuer
Helga | 4/23/2002 | 3/1/2004 | adipiscing elit, sed diam nonummy nibh euismod
Ianna | 11/1/2003 | 6/15/2005 | tincidunt ut laoreet dolore magna aliquam erat volutpat.
Jane | 1/7/2006 | 4/23/2002 | Ut wisi enim ad minim veniam, quis
Kathy | 3/1/2004 | 11/1/2003 | nostrud exerci tation ullamcorper
Leonard | 6/15/2005 | 1/7/2006 | suscipit lobortis nisl ut aliquip ex ea commodo consequat.
Mike | 4/23/2002 | 3/1/2004 | Lorem ipsum dolor sit amet... consectetuer
Nancy | 11/1/2003 | 11/1/2003 | Adipiscing elit, sed diam nonummy nibh euismod
Oswald | 1/7/2006 | 1/7/2006 | tincidunt ut laoreet dolore magna aliquam erat volutpat.
Peter | 3/1/2004 | 3/1/2004 | Ut wisi enim ad minim veniam, quis
Qunicy | 6/15/2005 | 6/15/2005 | nostrud exerci tation ullamcorper
Ronald | 4/23/2002 | 4/23/2002 | suscipit lobortis nisl ut aliquip ex ea commodo consequat.
Stacy | 11/1/2003 | 11/1/2003 | Lorem ipsum dolor sit amet... consectetuer
Tim | 1/7/2006 | 1/7/2006 | adipiscing elit, sed diam nonummy nibh euismod
Uylsses | 3/1/2004 | 3/1/2004 | tincidunt ut laoreet dolore magna aliquam erat volutpat.
Victor | 6/15/2005 | 6/15/2005 | Ut wisi enim ad minim veniam, quis
Walter | 4/23/2002 | 4/23/2002 | nostrud exerci tation ullamcorper
Xerxes | 11/1/2003 | 11/1/2003 | suscipit lobortis nisl ut aliquip ex ea commodo consequat.
Yanni | 1/7/2006 | 1/7/2006 | Lorem ipsum dolor sit amet... consectetuer
Zelda | 3/1/2004 | 3/1/2004 | adipiscing elit, sed diam nonummy nibh euismod

## Filtering Table, populated from JSON data

Name | Date Added | # of accounts | Description
--- | --- | --- | ---